Commit Transaction
AutomatR.PostgreSQL.CommitTransaction
The "Commit Transaction" activity in AutomatR is part of the PostgreSQL activities package, facilitating the commit of a transaction. This activity is typically used in conjunction with the "Start Transaction" activity to manage database transactions effectively.
Properties
| Name | Description |
|---|---|
| Misc | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Commit Transaction" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
How to use:
- Drag and drop the "Commit Transaction" activity onto the workflow.
- Configure the optional delay if needed.
- Ensure that the "Commit Transaction" activity is placed within the scope of a "Start Transaction" activity.
- Execute the workflow to commit the ongoing transaction.
Example: Consider an example where the "Commit Transaction" activity is used to commit a transaction:
Commit Transaction:
Delay: 2
In this example, the activity commits the transaction with a 2-second delay. The commit operation finalizes the changes made within the transaction.